0

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
2
Views
8 Years
Discussion Span
Last Post by vb5prgrmr
0

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

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.