|
Joined: Sep 2005
Posts: 9,288 Likes: 10
Admin
|
Admin
Joined: Sep 2005
Posts: 9,288 Likes: 10 |
Anyone familiar with working with relationships between tables and forms with linked tables and subforms. I have some questions and would gladly pay for some support on getting through a project I am working on.
Also whats a good source for learning SQL
|
|
|
Visit Atcom to get started with your new business VoIP phone system ASAP
Turn up is quick, painless, and can often be done same day.
Let us show you how to do VoIP right, resulting in crystal clear call quality and easy-to-use features that make everyone happy!
Proudly serving Canada from coast to coast.
|
|
|
Joined: Sep 2005
Posts: 9,288 Likes: 10
Admin
|
Admin
Joined: Sep 2005
Posts: 9,288 Likes: 10 |
|
|
|
|
Joined: Feb 2006
Posts: 826
Member
|
Member
Joined: Feb 2006
Posts: 826 |
The Microsoft Official Academic Course books are decent enough. The books I've worked with all come with lab manuals. https://ca.wiley.com/WileyCDA/WileyTitle/productCd-047006966X.html I haven't worked with Access in about 2 years, but I might be able to jog my memory. If you want to email your files and questions to me I can see what I can do this evening.
|
|
|
|
Joined: May 2007
Posts: 5,058 Likes: 5
Moderator-1A2, Cabling
|
Moderator-1A2, Cabling
Joined: May 2007
Posts: 5,058 Likes: 5 |
Merritt -
Are you locked into Access? I used to work with dBase - mostly with their DOS version but I did some work with their Windows products.
It was a lot cleaner than Access for my money.
Sam
"Where are we going and why are we in this hand basket?"
|
|
|
|
Joined: Jun 2007
Posts: 2,106
Member
|
Member
Joined: Jun 2007
Posts: 2,106 |
I'll help ya Merritt, when ya got time?
Learning access will help you get a basic understanding of SQL such as Tables, Relationships, SQL Queries, etc. It'd be like taking an SQL 101 class.
|
|
|
|
Joined: Sep 2005
Posts: 9,288 Likes: 10
Admin
|
Admin
Joined: Sep 2005
Posts: 9,288 Likes: 10 |
Sam I have been working with dBase sine DBII then went to Foxbase then FoxPro but my programs won't run with XP so I want to move my files to Access.
What I I'm working on at this point is I have the following tables
calls address customer invoices material_sold
I want to have one form that views the info from all the tables that relate to that customer. I am having trouble getting all the data to show from each table.
|
|
|
|
Joined: Jun 2007
Posts: 2,106
Member
|
Member
Joined: Jun 2007
Posts: 2,106 |
Well, it'd take me 3-pages to explain it, or I can show ya pretty quickly on your computer. Anyways, if you click on the title bar of the form, and open the properties dialog box, there should be an option to set the form source. This is where you can add tables and create relationships. If you have global relationships (like calls will always relate to a customer), then you want to define those in the database itself, and it will inherit to the forms.
|
|
|
|
Joined: Sep 2005
Posts: 9,288 Likes: 10
Admin
|
Admin
Joined: Sep 2005
Posts: 9,288 Likes: 10 |
Originally posted by Kumba: or I can show ya pretty quickly on your computer. OK your place or mine I would be glad to get a plane ticket and pay you for a day to get a few lessons.
|
|
|
|
Joined: May 2007
Posts: 5,058 Likes: 5
Moderator-1A2, Cabling
|
Moderator-1A2, Cabling
Joined: May 2007
Posts: 5,058 Likes: 5 |
Merritt - I'm running dBase IV for DOS and dBase 5.7 for Windows on XP now. Correction: Actually, I haven't run the WIndows one in a while, but I did run it for about a year.
No problems.
Sam
But if James will show you Access - go for it. Personally I hate it, but I've been spoiled.
"Where are we going and why are we in this hand basket?"
|
|
|
Forums84
Topics94,402
Posts639,368
Members49,808
|
Most Online5,661 May 23rd, 2018
|
|
2 members (BobRobert, dexman),
197
guests, and
289
robots. |
Key:
Admin,
Global Mod,
Mod
|
|
|
|