OH my...thank you so much for validating what I already suspected. And Yes nothing he sells is standard everything is custom. He even designs logos for people and businesses. He is willing to work with whatever I come up with so right now I am saying that these customer/organizations with have several order numbers all due on the same day.
Also I have already told him that he MUST give everyone an Organizational name....using the last name as his Organization. THANKS again for brain storming with me. I have not gotten all of my reports and forms to work exactly as I hope they will so probably will be asking again for your assistance. By the way is there a problem with my thinking that populating the customer form with the cbobox and then clicking on the order button to then give the old customer and new order a problem? I would then button to detail form. I haven't really got that to work right as you know....thanks S