2 tables for a parent and child record, where a child record has a reference field to a parent record

[ServNowDev]

Trying to create Table A (Parent) and Table B (Child) tables. Is it as simple as creating table A that extends the task table, and make table A extensible, then create Table B and extend it from Table A. How do I associate a field that can be reference in Table B from Table A. kinda of like the incident number showing in the problem ticket?

[dmathur09]

Hi Thomas,

Creating a child parent table is similar to creation of incident and incident task table. I would suggest to use the task table as a parent in creating the table. Association of a field is pretty straight forward, you would need to create a reference field on the form and that reference field would be referencing to the desired table.

Hope this helps.

Regards,

Deepankar Mathur

[Brian Lancaster · Accepted solution]

You just need to create a field on table B of type reference that references table A.

Edit: A note about your second part of your question. If you need a lot of the same fields and functionality on the child table that you would get from the task table I would extend it from task. For example most child tables are extended from task. For example incident_task, problem_task, change_task, etc. are all extended from the task table. It also helps in some cases with reporting as you can report on multiple task types when your report from the task table. I would not extend the child table from the parent.