New booking but storing table ID via temp var

[Ruegen]

How do I get a temp variable to store a value from one table into another?



I have people making bookings however it may not be in their area and the responsibility might be given to another however in the bookings table I need to record who made that booking.

How do I get their name to store from one table (tblOrganiser!ID) into the booking table (tblBookings!StoredID or name)using the temp var?

[June7]

I've never used tempVars.

Why do you need to store name? Just store their ID.

[Ruegen]

I've never used tempVars.

Why do you need to store name? Just store their ID.

Ideally yes store their id, but display their name - they aren't connected to the area so if I tell the form to grab the associated id of the organizer it will grab the person responsible for that are not the person logged in making the booking at the time on behalf of the person responsible.

[June7]

How do you know who is logged in? You save their name to a tempVar? Why not save their ID?

How do you know who the responsible agent is? Is this somewhere on the booking form?

For your situation, might be like:

Me.StoredID = IIf(tempVar <> Me.ResponsibleID, tempVar, Me.ResponsibleID)

I never used tempVars. I save the logged in user ID to a textbox on form that never closes (main menu) so it is always available for reference.

I have used global declared variables but maybe I should consider tempVars instead.

[Ruegen]

I don't need to log a person (as in track if they are logged in), they just have to type in their surname which the query matches with the surname of the employee given to the area. If they don't type in the surname then they can't see the area because the query requires the surname to be the same as the one that is allocated to the area. (done by linking the table in the query to the bookings table)

Instead of having to type in the parameter, the query fetches the current temp var (which you type in at the start). The problem is I want to match the temp var with an id and then have that id saved on the booking table. Then on the form display the name of that person according to the ID in that booking table.

So essentially via the temp I need a way to bring in the id. I could add to the booking form query the surname field from the organiser and if it matches the temp field then it logs the id.

I could save perhaps the tempvar which would be just the surname into the booking table - but that is not an id nor anything I can link back to the organiser table.

[June7]

I just don't know your db well enough to offer specifics. I have provided concepts now you need to figure out how to apply to your situation.

My users don't have to 'log in' either, they don't even have to type in their name. I grab their username from their network login, do a lookup to users table to get their ID, store ID in textbox on form. The ID is automatically saved with some records so we know who did what with the record at various stages of processing.

[Ruegen]

Nice setup you have

I was thinking of doing a Dlookup - have the ID placed in if the surname is the same - not sure on the code yet but I will post whatever I come up with.

[Ruegen]

I've sorted it by just pasting the surname tempvar into a field - that is enough for record keeping etc.