Potential Problems

[pkudrle]

I could be getting some work soon using Filemaker and I am hoping someone could

explain to me the trouble that can occur with Relational Databases. I have seen

some posting regarding the issues with Portals and the trouble they cause. But

I have not had any issues Pop up.

When I created a data entry system for tracking video dubbing orders I created

a main database (which contained the main information, title, dates, etc)

with three relational databases( for pick-up, duplication, and delivery).

My reasoning for doing this was that I needed to create records with

several fields in the three different areas(Pickup, Duplication, and Delivery) and

they needed to behave independently of each other. The reason being

that sometimes I would have 1 pickup, 3 different duplications performed,

and 2 deliveries, all for the same record in the main database.

Now, the database I created works well. And I can print out specifically

what I need with no hassles.

What problems could be created with the format I developed?

Also what suggestions would be given for doing it differently?

Would I have problems with exporting the information?

Thanks,

Paul