Schema Correct?

[sucoyant]

Good day!

I was given a task to create a database following this:

Collateral Types; the choices should be Boat, Motor, Boat Trailer, Travel Trailers, Slide on Truck Campers, Horse Trailer, Jetski, Pop-up trailers
Is there a way to be able to choice more than one option?
Things done: UCC prepared, Dealer supplied UCC, Nothing needed at this time
We will need a box for date completed and by whom.
And we will also need a box for the Customer State.


My schema looks like this:

The File table will hold the "date completed" (aka fileDate) and fileComments.

In just one form, they need to:
1. Add the employee who made the entry
2. Select the collateral type
3. Select the "Things done", (aka the prepItem in the Document table)
4. Select customer state.
5. Enter the customer name

Is my schema correct?
I tried to make a query off of it for the data entry form, but I got a bit lost. If my schema is in fact correct, would someone be kind enough to tell me as to how I would go about creating a query for the form?

Thanks in advance!!!


________________________________________

Buddha. Dharma. Sangha.

 

[randysmid]

Hi,
Here are the steps I would follow:
1) You can get the user name from the network using my FAQ on the topic: [faq705-2814]
2) The Collateral Type would be a listbox, based on a query.
3) The Things Done would also be a listbox.
4) The Customer State would be a listbox.
5) Finally, I would have a query that only contains the fields you wish to update.

HTH,
Randy Smith, MCP
rsmith@cta.org
California Teachers Association

 

[LarryDeLaruelle]

Whether the design is correct or not depends on what you are trying to accomplish.

I would ask, if the collateral is related to the loan, how is that identified in the structure? I would assume that an individual could have more than one loan with each based on a different collateral item/s. Also, if File has a relationship to Loan, how is that identified?

Larry De Laruelle
ldelaruelle@familychildrenscenter.org