Search results

i only want one record in tblTest for one CusID. i put it as a one-to-many relation because customers may not have a test status. but if they have, there's only one.

Hi all, I have 2 tables, tblCustomers and tblTest. tblCustomers CusID - pk Customer name tblTest TestID - pk CusID - fk Test status I want to prevent users from adding a new test status for a customer when he already has a test status. i'm using a command button to create new test...

Hi, Thanks for the articles. I actually feel that there's more i don't know when i try to learn more. I have once more made changes to my db just now. (I thought i had finalised the structure, yet i changed it again. =( ) I have a question, that is, is there a way to limit records to just...

thanks. i'll be reading up more on access over the weekend, before going further on my database.

EDIT: Ok, i found the reason. i should delete tblProfile, and use fkResID for my 3 subprofile tables instead. i haven't made the changes, but i think it'll work. thanks all. Hi Richard, Thanks for the reply. I have worked more on the database since then, and i agree about the contacts...

Hi all, I'd like to know if i'm going in the right direction with normalization of the tables. I've attached the database. Also, i've got a question regarding importing data into this database. I have 4 tables of data in excel, and one of my excel table is a combination of tblCustomer...