How to link recordsets when records don't match all the time?

[#1]

I have two tables that I used to link through a key in both tables. It did work well till I found that because some dates didn't exist in one of the tables, obviously records on those dates are not linked and did not show in my maps.

How can I solve the problem? Tables can be connected when DataRecepcao is past, but if I'm looking for events schedulled in the future - as a Marcacao (booking in Portuguese) also can be - it doesn't match and it has no data.

Table Recepcao:

trim(text ([Recepcao_CodCentro] )) & '-' & text(floor(num(DataRecepcao))) as Chave_CodCentroRec_Marc,

Table Marcacao:

trim(text(CodIMTT) & '-' & text(floor(num(ContentDate))))  as Chave_CodCentroRec_Marc

Thanks in advance.

afonso

[Anonymous]

please post your application and data as well.

your word sound like interval function.

[cesaraccardi]

Hi Afonso,

I suggest you to do the following: create a tablebox and add the fields Chave_CodCentroRec_Marc, DataRecepcao (if you have it in the table Recepcao) and also the field ContentDate (if you have it in the table Marcacao) than by simply selecting the values on DataRecepcao and ContentDate you shall be able to see the difference in the key field.

Regards,

Cesar

[#4]

Thanks for your quick reply.

Please find enclosed a file with the two tables that I need to assemble. You'll see there is records that do not match the date, i.e., there are records in Marcacao that are for the future of what has already happen.

I need this link to this table because all the others filters can be activated through this Recepcao Table, as Code_centro and Calendar.

I used to link these two tables the script I copied in the original message.

Thanks again for any help you can give me.

afonso

[#5]

Thanks Cesar, but my problem is because I have more dates in contentdate of Marcacao than in Datarecepcao.

For instance I have already records for tomorrow and today on Marcacao but not in Recepcao, so those records are not linked and I can select them.