Background
Someone created a Sybase database. No documentation.
The company needs certain data (see the MS Access tables) extracted from the linked tables (Sybase db)
That is what my project is then to create a UI to search on these fields, RE: ComboBoxes
They are obsoleting the Sybase db and can't be installed on newer computer stations. Hence the data extraction of pertinent information.
They have migrated lot of it to another system pushed by corporate.
Anyway, some data did not transfer, hence this data extractions in the 8 tables:
1. Members
2. Adv Dues
3. Dues
4. In Fee
5. BargainingUnitContract
6. Refunds
7. Job History
8. Store History
l plan on continuing to develop on the GUI re: PK to make the search functions more efficient. Though pretty quick since there's not that much data to work with and it will NOT grow. It's static data. Historical really, for them to finish referencing until their migrated system has all the info necessary / close out the existing billing from the old Sybase system where they won't need to do look ups anymore.