Link table

[kastaman]

Hello,

I've linked an table from an external db. The table itself contains 4 fields. I'm planning on creating a form so we can update the 4 field, but at the same time, I'd like the entries on these fields populate another table with the similar fields as shown below.

Link table:
Field Name
1
2
3
4

My table
Field Name
1 = (Link Table, Field Name 1)
2 = (Link Table, Field Name 2)
3 = (Link Table, Field Name 3)
4 = (Link Table, Field Name 4)

Can I get some advise on how I can accomplish this?

Thanks in advance,

Kastaman

 

[Darrylles]

Hiya,

This thread has been unanswered for a while.

My answer is a question: why duplicate data?

If you had given a valid reason for this, maybe someone would have answered.

Kind regards,

Darrylle "Never argue with an idiot, he'll bring you down to his level - then beat you with experience."