Hello Willem,
Just what are you asking, regarding this? What step(s) in the use case
you outline are you not sure how to do via Base might be the better
question?
Willem Ligtenberg wrote:
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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
