问题描述
我不知道如何最好地解释这一点，但希望有人能理解我的问题！
基本上，我正在创建一个新的数据库，但我有点磕磕绊绊阻止如何构造其中一个表。
我需要创建一个表来存储每个客户的约会信息。但是，每个客户可以有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.
推荐答案
这篇关于表结构帮助的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！