Underformularer forbundet

You can send the dB to dkTeBrSa@europe.lego.com
I have some ideas!

I will just make a simplified one and send for you, so that it will be easier to see the actual problem

OK!

Du kan ikke have autonummereringsfelt i en underliggende relateret tabel. Det skal være Langt heltal, da det er en fremmednøgle til hovedtabellen.

/Thomas

Hi Thomas> Thats also what I say! am in the process of chnaging things for him!

Hvad hvis jeg fjerner autonummerering, har jeg saa mulighed for at holde styr paa mine data soegning osv.

Hvis jeg fjerner autonummerering fra begge under formulare kan jeg jo ikke faa sammenhaengende records i de to underformulare

mark>Have you received a mail from me?

jo, netop Mark. Underformular/hovedformularen vil sørge for at tildele de rigtige nøglefelter til nye poster, sådan at værdierne bliver ens for de respektive poster!

Hi Thomas>Mark has a number of tables in his database and if he alters the autonumber field he will have to make his primary keys manually.
He has one sub form which has its link field set to the main forms (this is no problem) other than the primary key here is an autonumber field which is used as the foreign key to the next sub form (table). The next sub form has its link field set to the primary key (autonumber) of the first sub form.  So where does this get its value from if it isnt an autonumber (manually!).

Actually I think I can get it all to work, but I need some info from Mark. The database he sent isnt working as the original, so I need the original to make sure I am working on th esame problem, befor eI go any further!

mark> I have sent you a mail, could you please let me know if you receive it, as your mail address seems to be giving problems!

Kanon Terry

Hele min uge er redet, du for hermed dine velfortjente point, Idfeltet skulle aabenbart vaere paa den ene subform

thanks mark :o)