Full Version: Continuous form
UtterAccess Forums > Microsoft® Access > Access Forms
lrib123456
Hello.
I have a problem that is twisting my brain.
I have 2 tables. Table 1 has ClientID and ClientName. Table 2 has ClientID, invoiceNumber and Amount.
The user enters information to Table 2 chosing ClientID & ClientName form a combobox that has ClientID bounded.
What i want to show on a continuous form is ClientID, ClientName, Amount.
How can i do this?
theDBguy
Hi,
You would create a query joining the two tables using ClientID and then displaying the fields you want to show from each table.
Hope that helps...
jmcwk
Main Form
table1
pkClientID (Primary key AutoNumber)
ClientName
Sub Form
table2
pkClientDetail (Primary key AutoNumber)
fkClientID (Foreign Key to Table1 Number Datatype)
InvoiceNumber
Amount
Add Both Tables to the query
Join pkClientID to fkClientID
Add ALL fields from Table2 to the Field Row of the query
Add clientName from table1 to the Field Row
Save the query
Use the saved query as the Record Source of your subform when you enter a record in the subform client name will be populated
Hope that is what you were looking for
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.