填充表格与关系 [英] Populating Tables w/ Relationships

问题描述

您好！所以我拥有这个巨大的人员名单以及他们应该参加不同活动的不同地点。有没有办法可以创建位置表，说明谁应该在那里以及哪个事件？

Hello! So I have this giant roster of people and the different locations they are supposed to be at for different events. Is there a way I can create location tables that state who are supposed to be there and for which event?

所以我正在寻找的是;

So what I'm looking for is;

名册

名称   | 5K

Name  | 5K

黛比|水站

我想得到的是

水站

5K         |    10K       

5K        |    10K       

黛比   |   Greg

Debbie  |   Greg

感谢您的帮助！

推荐答案

您的表格显示谁应该在哪里类似于分配表。您需要位置ID，事件ID（这意味着日期与事件本身一起），最后是员工ID，以显示谁在管理该位置。

Your table to show who should be where is akin to a Assignment table. You need the location ID, Event ID (which would imply a date along with the event itself) and finally, a staff ID to show who is manning the location.

这篇关于填充表格与关系的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！