I hope you'll indulge another basic view question. I've read a number of threads on this, but am just starting to attempt views and am still somewhat shaky on the basics.

I've created a paramterized view in the view designer called Cfnamadd. This is basically a one to many (or maybe it's a one to many to many - I have a people table with a number of child address records. In each of the child records there are, among other fields, a city field, which links to a city table, and an address type, which similarly links to an address type table.

So my first basic question is: When I create this view, must I also include all the fields of those (I guess grandchildren) tables in the view (e.g. the address type code and address type name from my address table), or can I/should I simply refer to those types of tables in the rowsource and rowsource type - assuming in this case I'm using a combobox to display the values.)?

The second question has to do with the control source itself. What table should be listed in the control source for my controls, that of the view or the original table? I assume it should be that of the view, but then I'm not sure how to update the original table. Is that a case where I have to do something like: Replace originaltable.field1 with viewtable.field1, etc., then do a table update on the original table?

The third question is where is the correct place to update the parameter? For example, do I select my name, then grab my name id and update that parameter with the name id, then select the view, then requery()? Or do I have the order wrong?

Sorry for the really basic questions, but I'm trying to make sure I understand this whole thing before diving into the deep end.

Thanks,

Sylvia