By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,968 Members | 1,226 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,968 IT Pros & Developers. It's quick & easy.

Help with my table relationships and list box

P: 28
Hi,

I am trying to create a data entry form for users. I want part of this to be a list box that can have multiple selections. As it stands at the moment. I have a table for Event details called 'Event', a table for Universities called 'Universities' who may attend, and a table inbetween called 'Attending' to stop the many to many relationship by having the Event Id and University Id in. I don't know if this is correct? Could someone confirm correct table design?

If it is/isn't how can I add a list box to the event data entry form for multiple University selections to be made?

Thanks for looking.
Aug 11 '09 #1
Share this Question
Share on Google+
3 Replies


P: 28
Actually what I'm looking for is very similar to this I think:

http://bytes.com/topic/access/answer...able-using-vba

I'm no expert so I will see if this works.
Aug 11 '09 #2

Expert 100+
P: 1,287
Your table design is fine. The list box method will require vba to either work with a recordset or run sql commands. The other option is a form bound to Event containing a continuous subform bound to Attending with a dropdown where one can select a University.
Aug 11 '09 #3

P: 28
Yeah, you're right! After getting confused with all the VBA stuff on the previous link, your continuous form solution is much better. Works like a charm!
Aug 11 '09 #4

Post your reply

Sign in to post your reply or Sign up for a free account.