I am creating an asset-tracking database using FM7. This is the first database I have created from scratch in FM7 and seem to be getting confused with a couple of things. Firstly, the database I am creating has a table containing unique entries for each asset no. and there are fields relevant to whether the movement of that asset is inwards or outwards, should I create one table containing all the information for each asset no. or create three tables

I would use 2 tables, (1) Asset and (2) Location or something similiar. Asset would have all the data about the asset and Location would have a record for each time the asset is moved either in or out.

To change the layout based on a radio button put a button over each of the radio buttons to run a script that will take the user to the correct layout.

Thanks very much for your help. It's working as I expected but I now have another problem in that I need to use the radio button selected in a report but as it is not really the radio button that is being selected this is not showing up on the report I have created. Is there any way of getting around this?

Thanks

Susie