How to get a Default value from Another table with same field names (Lookup), Not a dropdown list. Access Web App

Question

Question Related to Access Web App,

There are 2 tables namely:

User Entry - Primary Data (9 Field Names: SAPID, Project Name, Project Manager, Group Head, Gross Margin, Advances, Retention, T & D for Stock Items, T & D for Trading Items)

User Entry – Planning Data (9 Field Names: SAPID, Project Name, Project Manager, Group Head, Gross Margin, Advances, Retention, T & D for Stock Items, T & D for Trading Items  from  (User Entry - Primary Data, type Lookup) + many more items)

Out Put Required:

All the 9 Items values (Default) , SAPID, Project Name, Project Manager, Group Head, Gross Margin, Advances, Retention, T & D for Stock Items, T & D for Trading Items

should be fetched from User Entry - Primary data. It actually fetches data when selected Lookup, but it is in drop down list.

but what I am looking for is if I add SAP ID as IN-XXX in User Entry - Primary Data ,

once I open User Entry - Planning data SAP ID should be fetched based on current data entered in SAP ID in User Entry - Primary Data .

I want only 9 values to be default from User Entry - Primary Data to User Entry Planning Data.

Hope the description is clear , in case if it isn't clear, please do let me know.

Note: I was uploading pics, I don't know it says body text cannot contain images or link until we are able to verify your account.

Thanks & Regards,

Satish Kumar G N

Answer 1

BUMP!!

Answer 2

>>if I add SAP ID as IN-XXX in User Entry - Primary Data ,

once I open User Entry - Planning data SAP ID should be fetched based on current data entered in SAP ID in User Entry - Primary Data .

 

According to your description, do you want to the 2nd table list go to the last record when you open it based on the enter in the 1st table?

You could refer to the following steps:

1)Create a Record in 2nd table under the On Insert event of the 1st table, setField value equals to the first one.

 

2)Add NewRecord macro and GoToRecord macro the OnLoad action of the 2nd table list

Set GoToRecord macro into last record