Xref: utzoo comp.sys.mac:37967 comp.databases:3558 comp.sys.ibm.pc:34472 Path: utzoo!attcan!utgpu!jarvis.csri.toronto.edu!mailrus!ames!uhccux!jgt From: jgt@uhccux.uhcc.hawaii.edu (John Tsang) Newsgroups: comp.sys.mac,comp.databases,aus.mac,comp.sys.ibm.pc Subject: inexpensive relational DBM Summary: relational databases for restaurant personnel record & performance Keywords: relational databases, Reflex, graphical (& statistical) databases Message-ID: <4818@uhccux.uhcc.hawaii.edu> Date: 10 Sep 89 17:37:00 GMT Expires: 25 Dec 89 10:00:00 GMT Reply-To: jgt@uhccux.UUCP (John Tsang) Organization: University of Hawaii Lines: 36 Among those inexpensive databases: Reflex+, Reflex for the Mac (Are they the same?), File, FileMaker, DBM in Works, Panorama, DAtabase, Record for the xxxxx, etc., which ones are relational type? (I think) I need a relational DBM, because it is for a company personnel records, which need a file for the application data, a file for the hiring data (W2, State W2, Payroll form, I-9, etc.), a file for Absence, No-Show, Late, ..... etc., a file for daily performance checklist, a file for Sales &/or # of customers handled each night, a file for hours worked per week &/or per day -- to keep track of the full-time employees, and, a file about med. insurance given. Oftentimes, it is essential, for example, to search who has been full-time but hasn't given the med. insurance, or, who has dropped to part-time but still hasn't been cancelled insurance; or, to check the Performance Checklist (file) against the Sales &/or # of customers records -- to check if the employees are good in sales, efficiency, service and other duties & performance. Thus, it needs to cross search several files simultanously. [It probably may be too slow to put all the data of one person in one record in one file.] (By the way, it is for a restaurant with about 70-50 employees -- and will expand to 100 in the near future.) I don't want to incur the expenses and time on heavy-duty DBM software, such as, Foxbase, Double Helix, 4th Dimension, dbMac, etc. However, I'm not eliminating to consider them, if it's necessary. Or, I actually don't need a relational database. (Both database for the Mac or pc are suitable: we have access to both systems -- however, preferably for the Mac.) * Please reply directly via E-mail. Brought to you by Super Global Mega Corp .com