1 Reply Latest reply on Jan 21, 2015 11:46 AM by philmodjunk

    empty identification rows


      empty identification rows


      I have one table with two columns: identification (one for each person) and diagnoses (many/variable amount for each one), but the identification is filled only on the first row of each person and the next row/rows are empty. How to fill to identification data on each empty row for each person until there is a new person/idenfication and again variable amount of empty rows below.

        • 1. Re: empty identification rows

          That's a bit vague, but this sounds like you are trying to use one table to record data that really should exist in two related table. In one table, you'd have just one record for each person and an auto-entered ID such as an auto-entered serial number. In the other table, you'd have one record for each diagnosis. A relationship would lik the two tables by ID fields.