I create two table in the MS SQL server so I need to retrieve file from this two table into one datagrid in the vb programming will it be work. I have a unique key that is badge id. So when I key it then it will get data from this two table but this two table will contain bit different of data one is new user which show an active data and one is old data user that show unactive id badge so will it be work of this table structure. Beside that in the datagrid it also can direct edit of it. So it this table structure correct ??
gingank
0
Junior Poster
Recommended Answers
Jump to PostOkay, if one table is a listing of ID badges and the other table is a log table of when that badge is used (login/logout) then yes, that sounds like the correct database structure.
Good Luck
All 2 Replies
Reply to this topic
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.