表结构帮助 [英] Table Structure Help
问题描述
我不知道如何最好地解释这一点，但希望有人能理解我的问题！
基本上，我正在创建一个新的数据库，但我有点磕磕绊绊阻止如何构造其中一个表。
我需要创建一个表来存储每个客户的约会信息。但是，每个客户可以有0个约会或最多6个约会。在现有数据库中，使用了连续表单，但在查询不同报表的约会时会出现问题（例如，查询有多少客户参加了他们的第2 /第3 /第4次约会等）。
我的问题是 - 是否有一种创建表格的方法，可以在需要时添加约会，因为我正在考虑解决它的方式是给每个客户6个预约' 'slots''但这有点多余，并且在Appointments表中有很多空白条目。
I''m not sure how to best explain this but hopefully someone will understand my problem!
Basically, I am creating a new database but am at a bit of a stumbling block as to how to structure one of the tables.
I need to create a table to store Appointment information for each client. However, each client could have 0 appointments or up to 6 appointments. In the existing database, a continuous form was used but this caused problems when querying the appointments for different reports (for example, querying how many clients attended their 2nd/3rd/4th appointments etc).
My question is - is there a way of creating a table that will add appointments in when needed as the way I''m thinking of solving it is to give each client 6 appointment ''slots'' but this would be a bit redundant and have a lot of blank entries into the Appointments table.
推荐答案
从你的帖子中不清楚为什么你有问题。你可以发布客户端和约会表的元数据，这样我们就可以看到现有的结构，然后我们可以找出问题所在。
这是一个如何发布的例子表MetaData：
表名= tblBookings
It''s not clear from your post why you were having problems. Can you post the metadata of the client and appointment tables so we can see the existing structure and then maybe we can figure out where the problem lies.
Here is an example of how to post table MetaData :
Table Name=tblBookings
嗯，这是现有的设置。我正在创建的那个只有一半设计，因为我现在卡住了！
我不会发布存储在Client表中的所有信息，因为它'这里不相关。
Well, this is the existing set-up. The one I''m currently creating is only half designed as I am stuck at this point!
I won''t post all all the information stored in the Client table as it''s not relevant here.
数据的添加方式无关紧要。
使用以下结构...
It shouldn''t matter how the data is added only how it is stored.
Using the following structure ...
这篇关于表结构帮助的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
