troubleshooting Question

How do i fetch data from one table to another (lookup) - Related to Access Web APP

Avatar of Satish Kumar G N
Satish Kumar G NFlag for India asked on
Microsoft AccessMicrosoft SharePointMicrosoft Office
13 Comments1 Solution372 ViewsLast Modified:
My question is related to Ms Access Webapp.

I have 2 Tables (Fields):

User Entry - Primary Data (SAP ID, Project Name, Project Manager)

User Entry - Planning Data (SAP ID (lookup from prev table), Project Name (lookup from prev table), Project Manager (lookup from prev table), many more values (not lookups from prev table))

I want to know how can I import values entered in

User Entry - Primary Data (SAP ID, Project Name, Project Manager)

to

User Entry - Planning Data (SAP ID (lookup from prev table), Project Name (lookup from prev table), Project Manager (lookup from prev table), many more values (not lookups from prev table))

what data macro to be used? or insert event or anything else.

Note: while answering please use my terms and answer please.

Thanks & Regards,
Satish Kumar G N
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 13 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 13 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros