footie11

Newbie working on the DB design

Discussion created by footie11 on Apr 2, 2013
Latest reply on Apr 2, 2013 by gcatnine

I'm currently working on my first DB!!! I can't get my head around one scenario.

 

I'm trying to track the equipment we sell and install on boats. Each boat has a shipID primary key and a Name as well as some other attributes. The problem I have is the "name" may change over time, so I've thought about adding another column as "exname"; so when the name changes I just update with new name an move original name to exname!

 

But.... Often a boat could have 3 4 5 exnames over time and this would break the "normal form" rules I've been reading about.

 

I need to be able to query a "name" and return shipID's for both current and exnames!

 

Also multiple shipID's could have the same "name"

 

Thank you in advance for any advice.

 

USING FMP11

 

JF

Outcomes