INSERT new record to the related table?

[muzafar]

Greetings,
I have two related tables. One is requisition and other one is requisition_items. Requisition is the main table which contain fields like
Id (PK),
req_no,
name,
date.

And requisition_items table contains fields,
id,
item_name,
unit,
requisition_id(FK).

Now what I want is, that I want to show the form like this.

Name: _______TextField__________
Date: ________TextField____________
Item Name _________TextField___________
Unit: _________Select List________

I am trying to use grid to add new record, but it doesn’t seem to work. I want that the form should show the form fields from both the tables like above.
I am using grid like this.
[items]
widget:label = "Items"
transient=1
relationship=requisitionitems
widget:type=grid
widget:columns="pricePerUnit,unitCount,items"
order=10
group=Project

Kindly lead me, and tell me if this is possible with grid or let me know if there is any other method.
Your cooperation on the above will be much appreciated.

Thanks

[shannah]

I think you're on the right track with the grid widget. The layout won't be exactly what you specified but it will be functionally equivalent.

I need more details in order to assist you? E.g. what do you mean by "it doesn't work"? What does the form look like now? What specific things need to be changed? Have you specified a relationships.ini file - and if so what does it look like?