I have a database with 3 tables where the data is imported monthly. One table always has entries, the other two may not have entries. The only fields they...

I have been given the task of replacing our old program for report writing. Unfortunatly my knowledge in Access is limted to none. If anyone is willing to...

Thank you in advance, My company is willing to pay for a course in database design (not too costly) and was wondering if anybody could give me any suggestions....

hi, i have two tables one called personel info and the other called affiliation (taekwondo). I would like to be able to enter dats in personel info and...

My client is used to seeing data a certain way, and I can not seem to sway her. I'm trying to normalize her database, and we're making pretty good headway,...

Here is an absolutely minimal spec for my little time management system: 1) A set of projects. Each project has a set of tasks. 2) Every day, I make a number...

I have an audits database, with several tables, tblAudits -- overall information about each audit, like who is doing the audit, the date, where, etc. AuditID...

Hi, I'm still a newbie in database design (this one is only my third database). I have some difficulties designing the tables and relationship for an...

I notice ur 10 commands say never expose the autonumber. I have 2 tables tblContracts and Lots linked 1 to many enforced on autonumber in tblContracts. That...

Hi. I think I have a problem with my table set up. My main form is Individuals (based on tblContacts)and it has a subform set upf or payables. The payables...

I'm self-taught and my computer has come close to extinction on more than one occasion. I'm creating an access table and trying to add hyperlinks to...

I've split my test run and most everything works great. However, how do I provide a multi-user environment that does not allow each user to...

I think I've run myself up a blind alley... hope someone can redirect me in a more productive direction... I have an existing system for tracking real estate...

I have a table where the "natural" primary key would be a combination of four fields. And for a while, we worked with it that way. Then I became convinced...

Hi NG, I have an Access DB with a VB front end connecting through ADO. I have a table containing settings with around 30 fields. By way of...

Hi All, I have a surprisingly simple, but complicated database requirement in that the database requires only 5 tables, but includes a circular reference...

Just wanna be sure that after writing so many tables .oof +++ I think I'm crazy asking this... IMHO, I'm properly storing Prospect ID pk then FirstName then...

Hello All, I have a membership database, members can buy examinations, membership subscriptions and items (mugs, ties etc). I have a table linked to...

TblUnits Name Type Size UnitID Long Integer 4 PK PropertyName Text 50 BuildingName Text ...

Hello: Can someone please explain the difference between setting multiple primary keys and disallowing null values. For example, If I have Table1 with PK A...