Undecided

[Jose Aleman]

Hi all,

I was wondering if someone can help me with my problem. I'm creating a
database for our little department receiving documents.

I have three tables.
Loans: Main Loan Data.
Hud: We can receive a file from the Title Company.
File: Receive File from our Account Managers.

The hud and File table both have the same information: Receive Date,
Received By, Issues, Ship Date.

Should I leave this two table seperately or could I combine them and
Differentiate the field with Hud _Rec_Date and File_Rec_Date.

Any input is appreciated

 

[Lynn Trapp]

I would combine the 2 tables but, instead of different date fields, simply
add a Received_From field which can have either HUD or FILE as values.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

 

[Jose Aleman]

We did think about that option as a drop down list. However, If the Hud is
received before the File, when the file is received it would then replace the
Hud.

We are working and learning. Fist time creating a database. It's a good
thing it's only for our team of five.

 

[peregenem]

The hud and File table both have the same information: Receive Date,
Received By, Issues, Ship Date.
I would combine the 2 tables but, instead of different date fields, simply
add a Received_From field which can have either HUD or FILE as values.

Use one table for the common information. Two tables for specific info
i.e. one for HUD and FILE. Create a VIEW (a.k.a. Query object, vitual
table) to present the data from the three tables as one (virtual)
table.