LogIn and display Related items from a second table

[swaggerking]

First off, I'm using Dreamweaver and an Access db. Second, I'm a novice.

I have two tables in my db: "tdClients" & "tdClientInvoic es". The only relation/common denominator in each table is the field "ClientID". Once I log in I want display info from the both tables dependent on matching ClientID.

My table layout:
_tdClients
uid (autonumber)
ClientID (text)
UserName
PassWord
FName
LName

_tdClientInvoic es
uid
ClientID (text)
Invoice
InvoiceDate
Comments

How do I login and also display the clients invoices based upon ClientID?

[jhardman]

You need to set a db connection, then open the connection with this query statement:

SELECT * FROM tdClientInvoices, tdClients WHERE tdClientInvoices.ClientID=tdClients.ClientID

Are you looking for the code for setting the connection too?

[swaggerking]

Thank you. You really helped me and it seems to working.

SELECT *
FROM Clients, Invoice
WHERE UserName = 'MMColParam' AND Clients.Custome rID=Invoice.Cus tomerID