Single entry for two tables?

[soojosie]

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

 

[Rich]

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]

pda query

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