Solved

form/subform design access

Posted on 2011-10-01
7
326 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 250 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 250 total points
ID: 36897000
test this, click on fileId from the files subform
trial.accdb
0
Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

 

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

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

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

Suggested Solutions

Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

726 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