How d I link records to one another in different tables
Posted on 2008-02-07
I pulled this very convoluted database from ACCESS and I had to split the tables, apprently I have impotred them into an SQL structure. The tables appear to have retained all of their relations. However, when I look at patients and scroll through that database the patient visits database is supposed to point to the visits which correspond to that patient, via the patient ID field in both. The designer says that there is a relation only link between the two tables, but the are both simply flat tables. This is supposed to be a relational database, as it was in ACCESS. Any ideas as to what might be going on? I have done a lo tof programming in relational databases, paradox, access, DB II, DB IV Alpha, etc but I am stumped on this.