can anyone tell me if it is possible to create many fields on a form which have a control source from the same field in a table, but can display different values on the form. or if there is another way of doing this without crreating multiple fields in the table
mulitple fields form one source (1 Viewer)
- Thread starter david444
- Start date
Autoeng
Why me?
- Local time
- Today, 17:14
- Joined
- Aug 13, 2002
- Messages
- 1,302
Can you provide some more detail as to exactly what you are wanting to do? For instance, you have a field with first, middle and last name all together but you want to break them up and display them in separate boxes on your form.
Autoeng
Autoeng
Hi David
I think you may be better off redesigning your table structure - if one record needs to display multiple instances of values from a field, then it sounds like a one-to-many relationship (2 tables).
This would mean that you could put a linked subform on your form, which would display all the (many) values for that field that relate to that (one) record.
HTH
Rich
I think you may be better off redesigning your table structure - if one record needs to display multiple instances of values from a field, then it sounds like a one-to-many relationship (2 tables).
This would mean that you could put a linked subform on your form, which would display all the (many) values for that field that relate to that (one) record.
HTH
Rich
