G
Guest
I need some help setting up a query. Here are the details:
I have the following tables:
tblLots (this is a site in a campground)
ID: AutoNuber (primary key)
LotNumber (the number of the lot in the park)
LotSteeet (the number and street for the address of the lot)
LotOwner (Lookup in People table)
LotRenter (Lookup in People table)
note: I do not store the city,st,zip since they never change in the park.
tblPeople (people who own or rent in the park)
ID: AutoNumber (primary key)
FirstName
LastName
Spouse
Then I have a query for updating information about a given lot. In the
query, I prompt for the lot number and then display that record. I have it
return the fields from the lot record, but I also use the following
expression to return a "display" name for the current lot owner (and it works
just fine):
CurrentOwner: [LastName] & ", " & [FirstName] & (" and "+[Spouse])
What I am not sure how to do is to build a similiar display name for the lot
renter. Basically, I have a lot record which has two related people records,
and in the query, I need to be able to get both of the people records and I
am not sure how to get the other one.
Thanksk for assistance,
Steve
I have the following tables:
tblLots (this is a site in a campground)
ID: AutoNuber (primary key)
LotNumber (the number of the lot in the park)
LotSteeet (the number and street for the address of the lot)
LotOwner (Lookup in People table)
LotRenter (Lookup in People table)
note: I do not store the city,st,zip since they never change in the park.
tblPeople (people who own or rent in the park)
ID: AutoNumber (primary key)
FirstName
LastName
Spouse
Then I have a query for updating information about a given lot. In the
query, I prompt for the lot number and then display that record. I have it
return the fields from the lot record, but I also use the following
expression to return a "display" name for the current lot owner (and it works
just fine):
CurrentOwner: [LastName] & ", " & [FirstName] & (" and "+[Spouse])
What I am not sure how to do is to build a similiar display name for the lot
renter. Basically, I have a lot record which has two related people records,
and in the query, I need to be able to get both of the people records and I
am not sure how to get the other one.
Thanksk for assistance,
Steve