Search results

EDIT: I have figured a way around this, but now i have a new problem. I have a table called 'Location' like this: LocationID Name (Text) Capacity (Number) Indoor (Yes/No) locations can be indoor or outdoor, for indoor I need to record whether there is internet or not, and for outdoor I need to...

yes but that only works because sponsor is the only type that has parameters, the other ones dont and so access wont create them for me because i dont enter anything.

I am not sure where to find these options, but I think I have set up the relationships correctly. I have uploaded an example of my database here: http://download.yousendit.com/6839E9A1131E5257 The form in there will add people to the persons table as Hosts but it doesn't also insert an entry...

I have four tables, the main one is like so: table Person: PersonID Firstname Address Type ["Host", "Organizer", "Sponsor"] the other 3 are like this: table: Hosts HostID PersonID table Organizers: OrganizerID PersonID table Sponsors: SponsorID PersonID Cash Description Each person can only...