Forum Discussion
Solved
Cant Create form Using 2 x Sharepoint Linked Tables
Hi I have 2 x tables Plant Orders and Plant Orders Details that are linked from Sharepoint. I have a user input Form whereby the Plant Orders Form is the Main Form and Plant Order Details is the Subf...
Hi,
This is easily done with a query but it is not editable when running the query on both Tables.
You should post the SQL text of the query.
Servus
Karl
****************
Access Forever News DevCon
Access-Entwickler-Konferenz AEK
Thanks for your help, the issue as advised was that there was no lookup field in SharePoint List to create the one to many relationship that would have allowed the Query to Run. When i originally created the Main and Subforms this was done without a lookup column for the identical Fields.