Unable to edit Data in Query

[undee69]

Hello there.

Good day to all. Hope you could assist me with my issue. I am relating 4 tables in a query but somehow I am not able to edit the output records.

Here is what I got:



tblpayment:: ID,date,Bookmonth,EmpName,
tbllvl1:ID, tblpaymentID, acnt1_Lvl1,acnt2_Lvl1,acnt3_Lvl1
tbllvl2:ID, tblpaymentID, acnt1_Lvl2,acnt2_Lvl2,acnt3_Lvl2
tbllvl3:ID, tblpaymentID, acnt1_Lvl3,acnt2_Lvl3,acnt3_Lvl3

As you can see, I am relating the [tblpayment].[ID] to tblpaymentID of the other tables.
I am doing this for instances that the empName will have to enter one or more accounts with different levels.

[Missinglinq]

Many multi-table Queries are Read-Only. Allen Browne gives an excellent explanation here:

http://allenbrowne.com/ser-61.html

Your rather cryptic Field names makes guessing what you're trying to do difficult, but data entry in this kind of situation is usually done thru a Main Form/Subform scenario, with the Main Form, here being based on the tblpayment Table and the Subforms on the other Tables. The linking Fields between them would be your ID field.

Linq ;0)>

[undee69]

Yes I have read that and I am not able to follow it though *sad*.
So if I'm gonna use subforms, that would mean i will be creating separate forms for each level of my tbllvl right?

[Missinglinq]

You will need to create a Form to hold your Main Table data, but when creating the Subforms, the Wizard will allow you to directly choose a Table as each ones Source.

Making a Form for each Table, then using that Form as the Source for the Subform, has the advantage of giving you more control over how the data is entered, but in a simple application this isn't always needed.

As I said before, your cryptic Field names makes it difficult to guess exactly what you're doing here, but it would seem, superficially, to be relatively straightforward for the tbllvl1, tbllvl2 and tbllvl3 Tables.

The similar names of the Fields of each Table also makes me wonder about the normalization, or rather lack of normalization, of your data, but that, too, is impossible to gauge, given what we've been presented with.

You might want to check out CyberCow’s list of links on the subject of Normalization. The list appears on Post #5 of this link:

http://www.utteraccess.com/forum/Use...-t1986675.html

Linq ;0)>
.

[undee69]

thanks again Linq ^_^