I have 2 tables named "property" and "Rent" joined with Rent.PropertyID and Property_ID
1 property can have multiple rents.
Property Table: Property_ID; Property_Address
Rent Table: Rent_ID; Property_ID; Rent_Amount
If I create a Tabular form, I will see for example in the result page: Rent_ID = 1; Property_ID = 1; Rent _Amount = $1000.
I will be able to delete, edit and add. But I will see Property_ID =1 and not the Property_Address. For a final user "1"doesn't mean anything.
So, I create a VIEW with the tables "Property" and "Rent". I can see the property Address in the result page. However it's impossible to Edit, Add or Delete.
Is there a solution to edit at least (to change the rent_amount or the property address if it has been inserted by mistake)?
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
DoDoTwin
Hello,
I have 2 tables named "property" and "Rent" joined with Rent.PropertyID and Property_ID
1 property can have multiple rents.
Property Table: Property_ID; Property_Address
Rent Table: Rent_ID; Property_ID; Rent_Amount
If I create a Tabular form, I will see for example in the result page: Rent_ID = 1; Property_ID = 1; Rent _Amount = $1000.
I will be able to delete, edit and add. But I will see Property_ID =1 and not the Property_Address. For a final user "1"doesn't mean anything.
So, I create a VIEW with the tables "Property" and "Rent". I can see the property Address in the result page. However it's impossible to Edit, Add or Delete.
Is there a solution to edit at least (to change the rent_amount or the property address if it has been inserted by mistake)?
Thanks
Link to comment
Share on other sites
3 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.