Getting the current primary key value into another table

[syedalisajjad]

AOA,



Dear Khalid bhai,

Thank you very much for your time and effort in helping me out. Thanks a lot. My problem is solved. Sorry for replying late, i was out of city.

JAZAKALLAH

[khalid]

Walikum O Salam!

Glad that it solved your problem.
Good Luck!

[Sudha]

Hi Khalid,

I required your kind help.

I am new to MS access 2003.

Problem:

I have 9 tables all are interrelated with one primary key from header table.

I need to get the PKey value from header table to all the other tables.

Could you please help me urgently.

Thank you very much in advance.

Best Regards,
Sudha

[khalid]

Hi Khalid,

I required your kind help.

I am new to MS access 2003.

Problem:

I have 9 tables all are interrelated with one primary key from header table.

I need to get the PKey value from header table to all the other tables.

Could you please help me urgently.

Thank you very much in advance.

Best Regards,
Sudha

Dear Sudha,
Kindly explain your problem by creating new thread in the forum. Your problem can ba solved after seeing your db structur and tables. Its easy to get the Fkey in all your tables if your db is properly normalized based on your goal what you want to achieve. You can use subforms based on your main form to get the desire results.