Configure option button to output to memo box

[cdcox]

Alright, I'm running out of options!! I have several pieces of equipment that use text file configuration data. What I want to do is create an option button for each piece of equipment so that when I click that option button, its output ties directly to a memo box.

What I want to be able to do is have 7 different option buttons and each time I click a different option button I can paste text file config data for each piece of equipment into the same memo box and save it. That way, when I query a particular site ID and look up configuration data for any one of those pieces of equipment, I will be able to view the saved config files in the same memo box just by selecting a particular option button.

Is this possible? I've tried subforms, tabs (although I can't seem to be able to use tabs within tabs), option groups, etc. Any suggestions or help would be most certainly appreciated!

 

[Pat Hartman]

Almost anything is possible but that doesn't mean that you should do it. You have an order entry application. You need to use the traditional structure. You should not be storing the item details in a memo field. They need to be in their own table.

tblCustomer:
CustomerID (autonumber primary key)
CustomerName
etc.

tblOrder:
OrderID (autonumber primary key)
CustomerID (foreign key to tblCustomer)
OrderDate
etc.

tblOrderItems:
OrderItemsID (autonumber primary key)
OrderID (foreign key to tblOrder)
ProductID (foreign key to tblProduct)
Quantity
UnitPrice

Take a look at the Northwinds or Orders example databases.