Guest_imported
New member
- Jan 1, 1970
- 0
I have a DB for a conference my company puts on.
One presenter can present many presentations. One
presentation can have many presenters. (many to many)
tblPresentation (AutoNum-PK, title, date, location, etc)
tblPeople (AutoNum-PK, address, email, etc)
tblJoin (PKs from both tables)
A presenter can get billed for the presentation- or it
could go to someone else. A presenter could get sent all
the information, or it could go to someone else i.e.
secretary.
I need to have a report that will give me all the
presentation information, the bill to, the presenter etc.
Any help would be greatly appreciated.
Cheers
One presenter can present many presentations. One
presentation can have many presenters. (many to many)
tblPresentation (AutoNum-PK, title, date, location, etc)
tblPeople (AutoNum-PK, address, email, etc)
tblJoin (PKs from both tables)
A presenter can get billed for the presentation- or it
could go to someone else. A presenter could get sent all
the information, or it could go to someone else i.e.
secretary.
I need to have a report that will give me all the
presentation information, the bill to, the presenter etc.
Any help would be greatly appreciated.
Cheers