Create a table to hold the links. You will need some way of updating this. CREATE TABLE OperationParts + (OpParts ID INT NOT NULL PRIM KEY, + PartID INT NOT NULL REFERENCES PARTS, + OpID INT NOT NULL REF LaborOps)
Locate a field on the report that is expandable and list the parts there. >I have a report (actually a service repair order) where I need to match >numerous part # to a single labor operation. > > >Any ideas > > > >Thank you >Ted Crom >Axelrod C-D-J > > -- Albert Berry Full Time Consultant to PSD Solutions 350 West Hubbard, Suite 210 Chicago, IL 60610 312-828-9253 Ext. 32 __________________________________________________________________ McAfee VirusScan Online from the Netscape Network. Comprehensive protection for your entire computer. Get your free trial today! http://channels.netscape.com/ns/computing/mcafee/index.jsp?promo=393397 Get AOL Instant Messenger 5.1 free of charge. Download Now! http://aim.aol.com/aimnew/Aim/register.adp?promo=380455
