irslan rafique
Registered User.
- Local time
- Today, 23:21
- Joined
- Oct 17, 2014
- Messages
- 26
Hi,
I am creating a database using Access 2010 Web Database.
I have two tables:
1-Maintbl with these fields:
1- Date 2- RTNo 3-DriverName 4- ConID 5-ConName
6- Zone 7- ZoneType
2- Consigneestbl with these fields:
1- ConID 2- ConName 3- Zone 4- ZoneType
These tables are linked with 1 to many (using ConID to ConID)
I want to make a form based on Maintbl where I enter ConID and the form should retrieve the values of ConName, Zone & ZoneType from Consigneestbl and save them in the Maintbl.
In desktop version of access 2010, I used dlookup to retrieve data and used afterupdate event to store data in main field. But in Access 2010 web database there is no VB and DLookup. Only Macros are available.
I will be very grateful for prompt help.
I am creating a database using Access 2010 Web Database.
I have two tables:
1-Maintbl with these fields:
1- Date 2- RTNo 3-DriverName 4- ConID 5-ConName
6- Zone 7- ZoneType
2- Consigneestbl with these fields:
1- ConID 2- ConName 3- Zone 4- ZoneType
These tables are linked with 1 to many (using ConID to ConID)
I want to make a form based on Maintbl where I enter ConID and the form should retrieve the values of ConName, Zone & ZoneType from Consigneestbl and save them in the Maintbl.
In desktop version of access 2010, I used dlookup to retrieve data and used afterupdate event to store data in main field. But in Access 2010 web database there is no VB and DLookup. Only Macros are available.
I will be very grateful for prompt help.
