View Full Version : Single entry for two tables?


soojosie
07-12-2003, 01:30 AM
I have a table containing info that I would like to access thru a PDA.
Problem is when reading data the PDA can only screen the first column e.g. FieldID only shows the number not the details from the lookup, unless you tab and that gets messy on a small screen.

Can I create a second table, fewer fields needed, with no ids only text?

I would need to be able to transfer data from the one form to both tables.

Thanks:confused:

Rich
07-12-2003, 06:12 AM
Doesn't your PDA have a Zoom facility? If it doesn't then use a query to return the fields you want, not another table

soojosie
07-13-2003, 03:00 AM
Thanks for your reply Rich, no the pda has no zoom, I did try a query first off, pda said that it was too complicated. Only has 8 fields 3 of which are connected to very simple tables.

When access runs the query there is no problem.

Do you know of any site that might be of help with access/pda?

thanks again Josie.
but still:confused: