Member Avatar for gingank

Hi guy i need some help on checking this table structure is right or wrong. PLEASE CORRECT id i'm wrong

tblBadgeNew
iBadgeID (Foreign Key)
iEmpID (auto number)
iActive
iRecycleStatus
iIssueDate


tblBadgeOld
iBadgeID (auto number)
iEmpID (auto number)
iActive
iRecycleStatus
iIssueDate


This two table will send data to the data grid inside the vb program after the user enter the BadgeID

  • 2 Contributors
  • 1 Reply
  • 105 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by vb5prgrmr
Member Avatar for vb5prgrmr

Look up tables

tblBadges
iBadgeID (AutoNumber, Primary Key)
iBadgeNo (number)

tblEmployee
iEmpID (AutoNumber, Primary Key)
vFName (text)
vLName (text)

operations table

tblBadgeStatus
iStatID (AutoNumber, Primary Key)
iBadgeID (Foreign Key)
iEmpID (Foreign Key)
bActive (Boolean T/F Active or not)
iRecycleStatus (number)
dIssueDate (Date)

which can also double as your history table

NOTE: There are way too many ways in which to organize your data and however you organize your data it needs to fit your requirements.


Good Luck

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.