Subform edits

[HZM]

Hey...
A Quick issue..!!

i've got a Form that contains Subform with an embedded Query that contains 2 tables only (Payments & Invoices) the Join properties between them show all records from payments and what matches it from Invoices where the joined fields are equal (Invoice no).. So, when i enter certain data in the main form the Subform show the results for it from Payments table and only one field needed from the Invoices table !!

The problem is.. i can't edit or add any data in the Subform results with the previous setting, but when i completely remove the Invoices table from the embedded Query then swift to the Form and it's Subform.. i become able to edit and add data in the Subform easily... !!

So, how to enable the edit/add in the Subform with the 2 tables in the embedded Query ?! Cause it's really needed to show that field from the Invoices table.. :/

Here's a ScreenShot that may help in understanding..

 

[jdraw]

The most common situation for Form/subform is when you have 2 tables in a 1 to Many relationship.

eg.    1 ---> Many
1 person has 1 or many Hobbies
1 Order has 1 or many Products
1 Invoice has 1 or Many Payments     

The 1 side table is the recordsource of the Form
The Many side table is the recordsource of the subform
Form and subform use Linking Fields common to both tables.

There are several youtube videos on this particular set up.

Good luck.

 

[HZM]

But there's no 1 to Many relationship between those 2 tables ..!!

 

[spikepl]

Oh yeah?

And the LORD said unto Moses, Come up to me into the mount, and be there: and I will give thee tables of stone, and a law, and commandments which I have written; that thou mayest teach them. And the Lord spake: these tables shall not have one to many relation - that relation they shall not have.

Is that what happened? If not, then why not then.