Drawing info from a table from a non-key field inMS Access.

C Newbie 0 Newbie Poster

14 Years Ago

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!

microsoft-access

Edited 14 Years Ago by C Newbie because: n/a

1 Contributor
0 Replies
60 Views

Be the first to reply

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.