new table has ruined previous relationships

[kibber]

Its ironic the second I get half to work the other half craps out on me....ehhhhhhhh

Used to have three tables related by last names:

Main : Last Name

Properties Last Name

DailyRequest : Last Name

Ran into a snag with multiple similar last names

So I added some more stuff and another table

Main : _ClientID

OWNERSHIP : __OwnershipID

Properties : _EiderID

DailyRequest : _DRID

My main & prop. tables are referecned through the ownership table using a script.

Eliminating the last name relationship has ruined two things for me:

1) the daily requests has to be chosen by last name - client calls in its the first thing you hear - So I had a value list which was property::lastname and is now main::lastname

from that I had a filtered valuelist property::Address which will not work since I'm asking it to filter across tables which are not directly tied together - they are linked via ownership.

2)Along the same lines as above I had a portal showing all the related daily requests within the property records. Since the addition of the ownership table and the loss of the last name relationship I can not get it to work again. I am hoping however, once I get the first issue the second one will fall into place. Anyone have any thoughts about this?

I have attached my database for anyone who is interested.

Thanks for all your help.

EiderInvestments.zip