Hi everyone,
I'm working on a Video Rental system in VB that needs to be binded with tables of information in MS Access. I have 4 tables (Employees, Members, Stock and Rentals) that need relationships with each other. I need to draw information from fields in 'Members' and 'Stock' so they can be viewed in 'Rentals'. How would I get the Rentals table to show the member_no and member_name from the 'Members' table and the stk_title from the 'Stock' table? Would this be possible? I have attached an image of the current tables.
Any help would be greatly appreciated!
Thanks!
C Newbie
0
Newbie Poster
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.