By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,241 Members | 799 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,241 IT Pros & Developers. It's quick & easy.

relationship status

P: 55
i am new to access and have little knowledge in database. i have been given a task to create a database involving client (a company request for a job) and job .

Primary key for Client is ABN and for Job, its Job number. My question is, the Job table consists of more than 70 fields and i want to split the table with one-to-one relationship. i dunno how to do this. when i split the table into 30 fields each with Job number in every table as the foreign key, it ends up with one-to-many relationship.

Also, in the Client form, i need to place a button called "Add more address" where i can add more than one address information for the same client. when i click this button, only the address fields like Street, post code, country must be listed in the same page of the form. i dunno how to do this.

i would appreciate your help.
Mar 22 '07 #1
Share this Question
Share on Google+
1 Reply

Expert 2.5K+
P: 3,072
Looks like a duplicate question.
I'll close thisone and lets proceed with the other one.

Mar 25 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.