Jump to content
  • 0

One to many relationships



I need to create a database to catalog archives.

I have one table for the box No and barcode and another table for the document information records of whats in each box.

I need to enter the Box number, then enter all the documents and once decided if the archive should be kept or destroyed, put in the barcode number for the storage company who will keep and retrieve the box.

If I create a one - many relations ship I should be able to pass the box No into the Document table but then I need to go back to the Box table and put in the Barcode table at the end.

I do not want to re-enter the box number for every document record.

Could anybody tell me how I set that up?



Link to comment
Share on other sites

2 answers to this question

Recommended Posts

  • 0

You can create a submission page based on box-no table and have this page as the destination after submission of information datapage. Then pass the box-no value you received in this page to the page you have created based on box-no table. If it does not answer the question then please give me the link of the page and provide more info.

:idea: :idea: :idea:

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...