1 Replies - 8142 Views - Last Post: 01 May 2014 - 10:33 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


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
  • +

Replies To: Creating Tables MS-Access

#2 burrina  Icon User is offline

  • New D.I.C Head

Reputation: 1
  • View blog
  • Posts: 33
  • Joined: 09-November 12

Re: Creating Tables MS-Access

Posted 01 May 2014 - 10:33 AM

What is PerID? Is it a Primary Key? To get the count of PerID, you would something Like;

Was This Post Helpful? 0
  • +
  • -

Page 1 of 1