hi there,

here's the example:

&id3=3&sd3=2006-10-02&ed3=2006-10-02&t3=title&d3=content&al3=0&et3=once&p3=&

My question:

as you can see the number 3 is always reoccuring within this row. It should be an autonumber and there's the tricky part: you can only use one autonumber per table. Is it possible to make one field (being autonumber) and let other fields within the table automatically get the value of the autonumber field? The reason for this is that the numbers need to change when I insert a record but the other fields then should be updated as well.

I hope my question is a bit clear.

thanks for your help,

Fledermaus

You are talking about parent-child relationships. If you have a formal relationship defined between the table that holds the "master" autonumber field and the table(s) that need to hold the number in its foreign-key context, Access will do what is required.

ok, I'm sure that you know what you are talking about bit this seems a bit difficult for me.

So you mean I have to create 2 tables. One with all the changeble data, one with all those autonumbers and delimeters (&d etc). Is it possible to afterwards parse them into one table and export this table as a txt file?