AnsweredAssumed Answered

Creating a file for Roommate Assignments

Question asked by avgraphics on Jan 11, 2016
Latest reply on Jan 11, 2016 by avgraphics

I have two tables - Rooms and Attendees - a one to many relationship.

This should be really easy, but I'm having a tough time with it -

I need to assign 2 attendees to each double sleeping room at a conference as well as single room occupancy     .

Here are the fields included the Rooms Table.

__pkRoomID

RoomType (Single or Double drop-down list)

Name1

Name2

[I want to use a Drop Down List of the Name field from the Attendees Table, in the Rooms Table - but the name disappears when I go to the next Record.]

Here are (some of) the fields in the Attendees Table:

__pkAttendeesID

_fkRoomID

Name

Room Type

 

Should I create a third new table called Roomates (and remove the Name1 and Name2 fields from the Rooms Table
to make all the relationships work?

Third Table - Roommates Field

_fkRoomID

Name1

Name2

(Still need a dropdown list to enter the names so I don't enter data twice).

 

I've spent several hours on this, studying Cris's Lynda.com movies...Feeling really dumb.

Can anyone help me figure this out please?

 

Thanks,

Angie

Outcomes