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

[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.

 

[Guest]

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