(in lessor table)
Expand|Select|Wrap|Line Numbers
- lessorID = autonumber
- lessor name = text
- address= text
- city = text
- state = text
- zip = text
- phone = text
the other table i have is the lease table it has this
Expand|Select|Wrap|Line Numbers
- leaseID = autonumber
- lessorID = number
- rentamount= currency
- leaseterm=text
- from = date/time
- to = date/time
i have put these on one form in visual basic 6.0 i want to have the datagrid have only the information that's in the adodc1(lessors table) so when i scroll throught the lessors table the datagrid will only show there information only. pleae help me understand this
lee123