>You still have one more option. You can bring up just one table (master) and provide custom controlsource (method seeking in lookup) for all columns showing lookup fields. Surely, this columns will become read-only, but usually it's Ok.
The thing I'm worried about now is not really a lookup situation. (Though I'm sure I'll need that, too) My problem is that I have a grid that lists all trips for the day. Because of normalizing, the client name is not attached to the trips. So the user has no way of seeing who the trips belong to. So I need to include the name from the clients table, and the rest of the info from the trips table, with the common key being clientID.
The way I understood the instructer to be saying to do it is to have the customer table and the trips table open with a relation, then in the grid have clients.name and trips.(whatever) for control sources.
So you're saying to do that with a view? What happens if I append a record to the view? Does that append a record to the trips table? Or do I need to write special code to tell it what table to append to?
Thanks,
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement