drashrafsabry
Well-known member
Table General has Field1 ID , Field2 Name , Field3 Phone
Table Visit has Field1 id_visits, Field2 ID , Field3 Notes
Table Requests has Field1 id_requests , Field2 id_visits , Field3 RequestSummary
Table general has table visit in Master/View where in form configurator i choose ID then added table visit and the primary key is ID
when i open table visit in master/view mode i choose ID field to show ID , Name
Now the question is , i want to add table Requests under visits , and i linked them ,
i want a way to display NAME from General table in requests table
Table Visit has Field1 id_visits, Field2 ID , Field3 Notes
Table Requests has Field1 id_requests , Field2 id_visits , Field3 RequestSummary
Table general has table visit in Master/View where in form configurator i choose ID then added table visit and the primary key is ID
when i open table visit in master/view mode i choose ID field to show ID , Name
Now the question is , i want to add table Requests under visits , and i linked them ,
i want a way to display NAME from General table in requests table