Web App displaying fields from another table in related items

[NathanBurley]

Hi All,

I have two tables to track our engineer visits, one tracks the visit as a whole and the other tracks the individual instruments the engineer worked on during that visit. This way I can track visits to customer sites separately to the visits made to an individual instrument.

Right now, I create a visit and then add Visit Lines (containing the details of the instrument visited). These instruments, or 'Visit Lines', are being displayed in the Visits Table via a related items box. Visit lines are associated with Instruments in the Instrument Table via a serial number lookup. All this works great...

...however, I want to display both the serial number and the instrument description in the related items control in the Visits Table. Since the Visit Lines table only has the instrument ID lookup and not the instrument description I can't display it in the control.

I need to either:

a) Create an instrument description in the Visit Lines table as a lookup and have this automatically pull in the description based on the serial number the user selects.... which I can't figure out how to do - it's just an autocomplete.

b) Create an instrument description in Visit Lines and have a macro grab the corresponding description from the Instruments table based on the serial number input - but just for this record... which I also can't figure out.

Please help - I've sliced this lots of ways and can't figure this out.

Many thanks,

N

 

[spikepl]

We have an entire forum dedicated to Access webapps (because they are different from standard Access). I hope a mod moves your posts, so that future readers easier can find them.

 

[NathanBurley]

We have an entire forum dedicated to Access webapps (because they are different from standard Access). I hope a mod moves your posts, so that future readers easier can find them.

Ah thanks spikepl - I hadn't realised this; I found the board through JeffConrad's responses to Jayne in the long post below which was very helpful. I thought this was the place as a result. I'll repost in the WebApp forum and ask a Mod to close this thread.

N