Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

form/subform design access

Posted on 2011-10-01
7
Medium Priority
?
333 Views
Last Modified: 2012-05-12
I have three tables:

Clients, who have many
Files which each have many
Invoices.

The tables are therefore linked that way.

I want to have cleints as the main form
That form will be tabbed.
On the first tab will be a Files. I have had no problem in building the subform
On the second tab will be invoices
What i need is the best way to do this:
To click on a File in the subform (first tab) and go to the corresponding Invoices on the next tab, and to be able to create a new invoice ID etc
There would there for be a clickable link from the (say) file ID to the invoices for that file.










0
Comment
Question by:topUKlawyer
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
7 Comments
 
LVL 6

Accepted Solution

by:
kswathi earned 1000 total points
ID: 36896221
If the file is only single selection then just create  invoices and a Combo box to select with the files corresponding to the client in the  third tab if it is ok (if the files are not many)  or what you think is also nice.
0
 

Author Comment

by:topUKlawyer
ID: 36896469
i am uploading the dbse fr you comments.

what i want to do is to be able to click on a file number in the first tab and then
go to the corresponding record on the invoices tab.
trial.accdb
0
 
LVL 120

Assisted Solution

by:Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1) earned 1000 total points
ID: 36897000
test this, click on fileId from the files subform
trial.accdb
0
NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

 

Author Comment

by:topUKlawyer
ID: 36899054
that upload seems a bit problematic but i cant work out why...

This is what im trying to understand:

If I have a table/form with clients ID then a sub form to reflect one client to many files, can i then make a sub sub form with one file to may invoices and then retain the link to the same client.
In other words for that one client with many files, when you select a "file' will the invoices sub sub form show the invoices for that selected file.

Can this be done with a sub sub form and how is it linked properly to the forms "above"

I have some familiarity with Master and Child links.



0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 36899546
di you test the revised sample db. ?
was there any problem using the revised sample db ?
0
 

Author Comment

by:topUKlawyer
ID: 36905271

 I have sorted it, I think. In retrospect the sample I uploaded was not too good and this may have caused it to behave oddly.

I wont bother you with the details.

I have done some further work on my own and having found a good example  i used an intermediate text box as a master and child link between two tabbed forms

I now have a much better understanding of sub forms, and sub sub forms.

Thanks for your help guys


0
 

Author Closing Comment

by:topUKlawyer
ID: 36905278
Points awarded for responding and being helpful
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …

609 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question