Managing same data between files

[JLShapiro]

Inventory Database files

How can I link several database files which has common items between all files.

Ex. Medication Stickers - is a similar item for 15 files. If I update inventory in file 1, I need all other 14 files to reflect this same update.

Thank you.

[JLShapiro]

I've gotten quite a few views but no replies to my post. Do I need to put more detailed information? Can someone please help?

Thank you

[bcooney]

One relates several FM files by using key fields. Read up on relationships.

[T-Square]

More specifically, store the inventory information in *one* table, and have all the other layouts display the data that is stored in the first table. You enable the display of this data through the relationships that bcooney mentioned.

David