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?).
pietlinden@hotmail.com wrote:[color=blue]
>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.[/color]
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200507/1 
