[AccessDevelopers] New DB Design Ideas

 

I am starting a new project that will track Daily Tasks. One of the tasks is to download and process files. Each day the number of files will change. I need to record the name of the file and several other pieces of info after the file is processed; i.e. Count, Transaction Number, Amount, etc.

Some days there will be only 10-12 files, other days there could be upwards of 70-75 files. I need to record each file for each day. Also, these files are associated with 3 different clients.

How would I design a table(s) that will allow this type of data? I have a DB setup but it ends up with empty rows on all but the busiest days. I would like to avoid that if possible.

Thanks for any tips or suggestions,
John

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 5

Visit Your Group

Please zip all files prior to uploading to Files section.

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___