Parameter query with DropBox through Form

[orange]

Further to Alan's recommendations and comments: The following will be helpful as you rethink your thoughts on Data bases.
Here are a number of free video tutorials related to database design concepts.

These free video tutorials describe the processes of data modelling, normalization and entity relationship diagramming. There are other videos, but this group is by the same presenter and covers an example situation.

http://www.youtube.com/watch?v=IiVq8M5DBkk Logical data modeling

http://www.youtube.com/watch?v=BGMwuOtRfqU Candidate key

http://www.youtube.com/watch?v=ZiB-BKCzS_I Normalization

http://www.youtube.com/watch?v=pJ47btpjAhA Normalization example

http://www.youtube.com/watch?v=q3Wg2fZENK0 1st Normal form

http://www.youtube.com/watch?v=vji0pfliHZI 2nd Normal form

http://www.youtube.com/watch?v=HH-QR7t-kMo 3rd Normal form

http://www.youtube.com/watch?v=q1GaaGHHAqM E_R Diagramming



http://www.youtube.com/watch?v=lXAGQ8vmhCY ERD Part 2

[alansidman]

I would have a separate table for the contractors and the developers and link them to your project table. Take a close read on the white paper to try and understand 1st Normal form and 2nd Normal form.

Also look at this site. Here are a couple of link to data layouts. Not exactly the same as yours, but will give you an idea about normalization.

http://www.databaseanswers.org/data_...ment/index.htm

http://www.databaseanswers.org/data_...ties/index.htm

http://www.databaseanswers.org/data_...pair/index.htm

and the main link for other types of db that you might find helpful

http://www.databaseanswers.org/data_models/index.htm

good luck and post back if you require more assistance.

[dbalilti]

Thank you.