Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 2 / May 2007

Tip: Looking for answers? Try searching our database.

Cascaded forms?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Ramesh - 21 May 2007 06:31 GMT
HI,

I have a Customer table and an Orders table.  I have another table with
PaymentSchedule table containing Instalment promises for each order.

Ideally i d create a form where I can either select an exisitng customer or
create a new customer.  Then select an order or create a new order.  Then
enter or modify the instalment details.

What s the best way i could achieve this?  is there some form of cascaded
forms i could create?

Thanks
Ramesh
Wayne-I-M - 21 May 2007 10:32 GMT
Hi Ramesh

Link the tables using the primary field of Customer table.

Create 2 new forms based on both table.

Link the forms - again using the control containing the Customer table
primary field.

Make the customers the main form and insert the other (orders) as a sub form.

Hope this helps

Signature

Wayne
Manchester, England.

> HI,
>
[quoted text clipped - 10 lines]
> Thanks
> Ramesh
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.