How to lookup info and having the correct relationship...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Sometimes the more I read, the more I question what it is I am doing... Okay
I have a tblRentalAgreement. I have a field named StatusRentalAgreement, and
I want this to look up what the status is of the Rental Agreement, ie. Open,
Cancelled, On Rent, Reserved. I am confident that I DO NOT want to do a
lookup in the table. I have done another tblStatusRentalAgreement and listed
the Open, Cancelled, On Rent, Reserved and in my relationships I made a one
to one relationship between the two tables (the relationship my need to be
different).

On my form frmRentalAgreement, I did a combo box utilizing the
tblStatusRentalAgreement (it shows as unbound--???), and it does work. My
question is: Is this correct? Or should I have pulled the
tblStatusRentalAgreement into the query that I am basing the
frmRentalAgreement on (which is based on 3 tables: tblCar,
tblRentalAgreement, tblMCRcustomer).

Any feedback welcomed. Thanks! m.
 
Hi Maura

The combo on the form should be bound to the field StatusRentalAgreement.

The source for the of the combo would look something like this

SELECT [tblStatusRentalAgreement].[PrimaryField],
[tblStatusRentalAgreement].[FieldName] FROM [tblStatusRentalAgreement];

Change PrimaryField and FieldName to what they are in tblStatusRentalAgreement
 
Back
Top