Forum Discussion
VBA userform
Hello, I am completely new to VBA and recently struggled through designing a userform with VBA (it was a tedious process). My problem, the first 4 columns in the database need to be the same wh...
Jan, thank you for your reply. Interestingly, I am currently taking a course on Access and started thinking the same thing, but I am not sure how to get the project relate to a number of millwork descriptions. I am learning. Thanks again.
AFter defining both tables in MSAccess, click on Database tools and click the relationships button. Drag the ID field from the projects table to the related project ID field in the millworks table to create a (one to many) relationship.