hi,
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.