Sorry but I'm a newbie. Maybe this has been asked before.
I'm trying to create a healthcare application and I need to be able to create the structure below:
Patient Table - Primary Key MRN #
Visit table - Key Date within MRN
Orders Table - sequential starting at 1 (auto increment by 1) within visit date within MRN
how can I accomplish this?
Any help would be greatly appreciated
(BTW I'm on Version 11 because I still run XP (and so do my clients))