LookUp向导 [英] LookUp Wizard

问题描述

您好

我正在尝试使用MS Access建立一个动物数据库，我在排序一个LookUp字段时遇到了问题

I am trying to build a zoological database using MS Access and I am having a problem sorting out a LookUp Field

家庭：表格 - 字段：父母，分类名称，作者，年份

Family: Table - Fields: Parent,Taxon Name, Author, Year

子家庭：表格  - 字段：父级，分类名称，作者，年份

SubFamily: Table  - Fields: Parent,Taxon Name, Author, Year

类别：表格 - 字段：父级，分类名称，作者，年份

Genus: Table - Fields: Parent,Taxon Name, Author, Year

父级Genus Table可以来自Family Table中的Taxon Name或Subfamily Table中的Taxon Name

The parent in the Genus Table could come from either the Taxon Name in the Family Table or the Taxon Name in the Subfamily Table

我可以让LookUp从两个表中的任何一个表中工作，但不能同时工作

I can get the LookUp to work from either of the two tables but not both

问候

推荐答案

这是设计的。

查找字段可能也是如此限制你的情况。连接表更常见，更灵活。

Lookup fields may be too restrictive for your situation. Junction tables are more common, and more flexible.

构建此类数据库是一件非常重要的事情。我们不知道你的技能，但这不适合新手。

Building such database is a non-trivial matter. We don't know your skill set but this is not for rookies.

在你做任何事情之前，你必须正确地获得数据库设计。你不是第一个这样做的人，所以要向那些在你面前的人学习。我希望你花几天的时间在搜索引擎上查找示例和较小的
掘金和其他寻求建议的人。

It is critical that you get the database design right before you do anything else. You're not the first one to do this, so learn from those who have gone before you. I would expect you spending several days with the search engines to find examples and smaller nuggets and others who have asked for advice.

这篇关于LookUp向导的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！