As a relative newcomer here, I could really do with some help:

I am required to create a database, then import the data from several
Access (spit!) tables, and create indexes, triggers/generators and FK
constraints.

The problem I have is with the sequence in which these should be done.

The structure of all the FB tables (and their indexes/constraints etc) has
been decided, and saved as an .sql

I modified the .sql script to only create the database and tables, then
pumped over the data (using dbWB), then attempted to add the indexes/FKs
and triggers/generators. This doesn't appear to work as I had hoped.

In these circumstances, is there an 'accepted' sequence to follow?

Cheers
Terry (dim-as-Toc-H-lamp) Riley