How to retrieve data from other table in Access 2010 web database

[irslan rafique]

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.

[twinnyfo]

irslan,

Unfortunately, you will have to build you Tables from within the Web Database. I have had little success in importing existing tables.

When you build your tables you can declare which other tables your tables will have relationships with. It is a somewhat slower process than a standard database.

However (unfortunately), much of the work you have done on the desktop version may have problems in the transition to web mode.

[twinnyfo]

This makes me wonder why Microsoft even offers a Web Access Database, since it appears so limited in what it can do and the difficulty in getting things to work.