OK, checked relationships, the tract is related to the others by the "lessor
id" and "lessee id", which is "id" in the respective table, i think that is
how it should be and master/child shows this correctly. You say i should
have the main form be lease or tract (which i have in a different table) but
i want to see what each owner has so i set it up to have the owner as the
main form (so i could search by name) with the tract info below in a subform -
is that the problem? Because of the way i have the tracts set up (because
that's how it needs to be), it has a many to one relationship with lessee
(one lessee per tract) but the same lessee can have multi tracts (isn't that
right?). I don't need to set out the lease separate from the tract, it can
be in the same table and i prefer it that way (is that a problem?). So, now
that i've explained a little more, any other suggestions? Oh, and yes, my
lessee field is bound to the lessee table (is that how it should be?).
pi********@hotmail.com wrote:
do you have relationships set up? Are your fields bound?
the relationships may look something like this:
Owner--(1,M)---Tract---(1,M)---Lessee
Owner(OwnerID(PK), Name...)
Tract(TractID(PK), Location...)
Lease(LeaseID(PK), TractID (FK), LeseeID(FK), LeaseStart, LeaseEnd)
Leasee(LeaseeID (PK), Name, Address...)
Main Form could be either Lease or Tract. (Probably Lease)
Combobox for Tract and either a subform or combobox for Leasee -
depending on your business rules.
Stuff to check:
1. The Master/Child relationship stuff in your form. they should NOT
be blank!
2. the relationships window. There should be relationships established
between your tables, then the forms should follow that.
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200507/1