Hi, I have a database that consists of 3 tables. 1) Visitor (at least containing VisitorID and a picture, as well as some other data) 2) Event (Containing EventID and a Date) 3) Event_2_Visitor (Containd Event_ID and VisitorID)
Now I want to create one from, In which I can do the following: I want to specify the date of the event once. (It should put this information in the Event database and remember the EventID.) Then I want to have a subform to input the visitors. Upon entering the VisitorID I want the picture of the visitor to come up. And some other data from the Visitor table. Also upon entering it should store the EventID and the VisitorID in the Event_2_Visitor table. So basicly I want to add new information to both Event and Event_2_Visitor. As well as query Visitor for some Visitor information that should be displayed directly (or after some event e.g. buttonclick or something) This form is meant for the following usecase: A new Event is started, the date is entered. A visitor wants to enter shows his badge with his id. An employee enteres this ID in the form, the database gets the information about the guest and displays that information. If correct, the visitor may enter and the EventID and VisitorID should be entered in the Event_Visitor table. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
