0 Replies - 5029 Views - Last Post: 21 April 2013 - 02:05 AM

#1 Pradeepfdo  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 23
  • Joined: 19-April 13

Creating Tables MS-Access

Posted 21 April 2013 - 02:05 AM

Sir,

I want to create a MS-Access Database,Tables for my requirements.

"MasterTable" have fields --------> "PerID", "PerName", "Repeat"
"PerID" peoples come repeatly.
Ex. When Come 3rd time "Repeat" Field updated as 3 in "MasterTables"

How I create other Tables for this Task.
When "PerID" repeat, for at that time -------> "OrderQty", "Company", "Picutre"(only file path) fields details must be enter to DB.

How can I create DB and Tables for this.

Ex. When "PerID" comes 3 times ---> there are
3 values of OrderQty,
3 names Company,
3 Picutre (File Path) - How I put to the DB.

Is there another way to know How many times repeat that "PerID", without entering value to "Repeat" field in "MasterTable"
Please Help to Create DB and Table for with sample field names.

Is This A Good Question/Topic? 0
  • +

Page 1 of 1