Search results

More questions Pat, please bear with me as I have less than a week experience with Access even though its been on my pc for a few years :) In order for me to get on with the project I will need some help clearing up some lingering questions that keep bothering me. When it comes to...

I started this post in the General area but it I believe it needs to be here now that the subject is about forms. I need to know the correct way to make a form that has fields from 2 or more tables that a user could enter the complete record using only 1 navigation control. I believe I figured...

I think I figured it out... Well, I guess I will be moving this discussion to the Forms area but I think I figured out my confusion. Initially I was adding the 2 tables to 1 form and trying to create the complete record, but I had 2 navigation controls. I think I need to use the sub-form, by...

Thanks, now onto the form Ok, I think I got my relationships correct but here is my next problem. When I use the form designer and select all the fields from the tblCustomers, and the DateOfService ServiceDone Results PriceOfService from the tblServices, I get the original problem thats been...

In the design you provided, would the relationships go from #1 to #2, and from #3 to #4? Thanks, sorebrain

That was quick Thanks for the quick reply. I will go to the other pc and have a go at it with this design. I am sure to have a few more questions as I ran into some situations I didn't understand with creation of the form. More on that later, I appreciate it, sorebrain :)

I need help designing a simple database. I thought it would be easier and I have become thoroughly burnt out :eek: It seems simple enough but I need help. I want to create a DB for customer records for my wife and her hair salon. Nothing fancy and just needs to replace the current index cards...