how to creat a sheet on form views

Dears:

I  manage our lab's chemicals by instant jchem.

How  to creat  sheets on form views like the attachment show

 

 

 

 

Hi, it seems you wnat to record multiple lots of each structure. To do this its best to use a relational model, with one table containing the structures a seond table containing the lot information. You would have a one-to-many relationship between the two tables, with one strucutre having many lots.

I'm not sure if you are entering the information manually or have data files that you need to import. But either way the basic approach could look like this:

 

1. In the projects window open the database you want, right click on it and choose 'New data tree and structure table'

2. Right click on that new data tree and chosoe 'New detail table'

3. Open the schema editor by double clicking on the database node in the project window

4. In the entities section locate the 2 newly created entities and add any additional fields you want to use.

5. Create a new form for the data tree and add widgets to it to show the data (there will be no data yet)

6. Add new rows to each table as appropriate.

Alternatively if you already have the data in files then you would improt the data into the database as two separate entities) and then create a relationship between them, define a data tree with the strucutre table as the parent and the data table as the child, and then create the form.

These links should help:

http://www.chemaxon.com/instantjchem/ijc_latest/docs/user/help/htmlfiles/relational_data/about_relationships.html

http://www.chemaxon.com/instantjchem/ijc_latest/docs/user/tutorials/import/htmlFiles/relational_form_build.html

 

Tim

 

 

Thanks very much

Sorry I do not have a clear description of the problem.

I actually want to only show  each structure's own related information in one sheet which can not include other structures'  informations.

 

example

we have many chemicals ,one of those might be bought from different suppliers,so it may have different price or different purity and so on.

 I neet to relate it own these different information in one table. 

 

By the way you described, I solved the problem

 

Thanks very much.