Hello,
Below is the correct schema, correct?
Home Table
ID
house_name
Home_Offer Table
ID
Home_ID
Offer_ID
Offer Table
ID
Offer_Amount
The idea is that many Homes can have many Offers.
When looking at the Home table record, the master/detail shows the Home_Offer record (all good).
When looking at the Home Offer table record, the 2 master/details configs (need both, Home and Offer)...
it is not showing up correctly???
1) it only shows the Home record, but it is the WRONG record? Have no idea how it shows the wrong record?
2) the Offer record is NOT showing. Not sure why this isn't showing.
I've looked at the simple data values, etc. multiple times... it is correct.
PLEASE do this same setup/schema and let me know if it works for you?
I'm sure it will not?
BUT if it does... I will find out my error?
NOTE: I already posted early, that using a view, does not allow you to update 2 tables
and My end resulting goal is to ALLOW users to search for Homes and then easily see/edit Offers.
Is there another way to accomplish this?
THANKS!!!
Below is the correct schema, correct?
Home Table
ID
house_name
Home_Offer Table
ID
Home_ID
Offer_ID
Offer Table
ID
Offer_Amount
The idea is that many Homes can have many Offers.
When looking at the Home table record, the master/detail shows the Home_Offer record (all good).
When looking at the Home Offer table record, the 2 master/details configs (need both, Home and Offer)...
it is not showing up correctly???
1) it only shows the Home record, but it is the WRONG record? Have no idea how it shows the wrong record?
2) the Offer record is NOT showing. Not sure why this isn't showing.
I've looked at the simple data values, etc. multiple times... it is correct.
PLEASE do this same setup/schema and let me know if it works for you?
I'm sure it will not?
BUT if it does... I will find out my error?
NOTE: I already posted early, that using a view, does not allow you to update 2 tables
and My end resulting goal is to ALLOW users to search for Homes and then easily see/edit Offers.
Is there another way to accomplish this?
THANKS!!!