It sounds like you've place three copies of the same field on your layout. If they are copies of the same field, changes in any one of the fields will display identically in all of them for the same record.
Yeah, that sounds like what I did. The thing is that I need 3 fields that have the exact same information (value sets) because of the nature of our project. Because it's an exhibitions database we are using the 3 fields to identify overlapping themes for each artifact that we enter. So for example: for a holocaust inspired painting it could be labeled variously under the themes of 'abstraction', 'modernity' & 'painting'.
So if I want to do that do I then have to create 3 seperate fields and link each field to a seperate values list even though they would contain the same information?
You would define three separate fields, but you can format them all with the same value list.
You might want to place one such field in a separate table and create a relationship so that you display this data in a scrolling list of related records in a portal. That approach gives you more flexibility and you can enter 1, 2, 3, 4 or even more such items of information for a given art object.
Thanks for your help. Basically what I've been doing is using the 'field tool' in the edit layout mode and dragging it into my existing database form and then double clicking on that to format the field as a drop-down menu with links to the appropriate value list. Is that what you mean by definining 3 separate fields? I'm totally new at this and someone else built the database but I've been assigned the task of adding stuff to it.
I had a look and we currently just have the entire thing built on one table.
No, that's how you got three copies of the same field on one layout. :smileywink:
Select Manage | Database | fields
Enter new fields by name here and click create. That defines a new field.
Their are many options here for each defined field. You'll need to spend some time learning about them. There are books and tutorials available that can supplement what you learn in forums such as this one.
Ahhh! Got it! Phil, thank you so much for your help and your patience. It's really appreciated. I'll def. try out some more tutorials when I have some time. Cheers!